USE [MMS]
GO

/****** Object:  Table [dbo].[MMS_MASTER_DATA]    Script Date: 11/07/2012 18:09:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MMS_MASTER_DATA](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[code] [nvarchar](max) NULL,
	[type] [nvarchar](max) NULL,
	[name] [nvarchar](max) NULL,
	[value] [nvarchar](50) NULL,
	[create_id] [int] NULL,
	[create_date] [datetime] NULL,
	[update_id] [int] NULL,
	[update_date] [datetime] NULL,
	[freeze] [varchar](1) NULL,
	[description] [nvarchar](max) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Constant presents for master data. Ex: ADDRESS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MMS_MASTER_DATA', @level2type=N'COLUMN',@level2name=N'code'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Constant presents for type of relative code. Ex: CITY with ADDRESS code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MMS_MASTER_DATA', @level2type=N'COLUMN',@level2name=N'type'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Display text in client''s view. Ex: TP. Ho Chi Minh with CITY type and ADDRESS code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MMS_MASTER_DATA', @level2type=N'COLUMN',@level2name=N'name'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ex: 01 value with Tp. Ho Chi Minh name and CITY type and ADDRESS code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MMS_MASTER_DATA', @level2type=N'COLUMN',@level2name=N'value'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1: delete, no activated, 0: activating' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'MMS_MASTER_DATA', @level2type=N'COLUMN',@level2name=N'freeze'
GO


